Hello,
I'm looking for a solution with UltraEdit before to buy it.
Is it possible to do this and how to do it ?
In my database (Mysql) I would like to replace some stuffs
Example :
In my file, I have 5000 rows
zipcode, 'city', 'Right_url_website',
means:
zipcode, 'Chicago', 'www.website-chicago.com',
and in this same file I have 8000 different rows
(id, 'department', 'area', zipcode, 'city', 'Not yet url website', 'address'),
means
(id, 'department', 'area', zipcode, 'Chicago', 'Not yet url website', 'address'),
I would like replace 'No_url_website' by 'Right_url_website'
It means:
Search 'chicago' ('city' = Column 2) if found 'chicago' ('city' = Columns 5) with 'No_url_website' (Columns 6) Replace 'No_url_website' (Columns 6) by 'www.website-chicago.com' ('Right_url_website' Columns 3)
Many thanks in advance for your answer
(I hope my English was not to bad because I'm French )
I'm looking for a solution with UltraEdit before to buy it.
Is it possible to do this and how to do it ?
In my database (Mysql) I would like to replace some stuffs
Example :
In my file, I have 5000 rows
zipcode, 'city', 'Right_url_website',
means:
zipcode, 'Chicago', 'www.website-chicago.com',
and in this same file I have 8000 different rows
(id, 'department', 'area', zipcode, 'city', 'Not yet url website', 'address'),
means
(id, 'department', 'area', zipcode, 'Chicago', 'Not yet url website', 'address'),
I would like replace 'No_url_website' by 'Right_url_website'
It means:
Search 'chicago' ('city' = Column 2) if found 'chicago' ('city' = Columns 5) with 'No_url_website' (Columns 6) Replace 'No_url_website' (Columns 6) by 'www.website-chicago.com' ('Right_url_website' Columns 3)
Many thanks in advance for your answer
(I hope my English was not to bad because I'm French )