DSXchange

Thanks for all the suggestions.

it is working now.

Thanks
Mark

Hi All, I have a file with 1 column and its data is as follows; Before: "Happy Hour, Party on 18"" staged on 20th." My Expected result; Happy Hour, Party on 18" staged on 20th. Can anyone please suggest me how do I remove the embedded quote in data stage while reading this c...

Hi All,

Can anyone please suggest me if there is any replace function in data stage. i could not find it in help. can anyone please suggest me how do i use it in data stage.

Thanks
Mark

Thank you. This is working partially. Before; "Happy Hour, Party on 18"" staged on 20th." After; Happy Hour, Party on 18 staged on 20th. My Expected result; Happy Hour, Party on 18" staged on 20th. Can anyone please suggest me how do I implement this in data stage. what stag...

[quote="filename.txt"]Try...

sed 's/""/,//g'<oldfilename>newfilename[/quote]

it says sed: Function s/""/,//g cannot be parsed.

Thanks
Mark

[quote="filename.txt"]Try...

sed 's/""/,//g'<oldfilename>newfilename[/quote]

it says sed: Function s/""/,//g cannot be parsed.

Thanks
Mark

Hi All, I have a file with 1 column and its data is as follows; "Happy Hour, Party on 18"" staged on 20th." Can anyone please suggest me how do I remove the embedded quote in data stage while reading this column. awk or sed might be able to do the trick using external filter stag...

[quote="ray.wurlod"]Parallel jobs don't handle this. You could solve it by pre-processing the file (for example using [b]sed [/b]or [b]awk [/b]command) to convert the double double-quote characters to something else, th ...[/quote] can anyone please suggest me how do i accomplish this with...

It is a variable length record i am receiving from my client. is there any way to remove those embedded double quotes and read the entire file.

Thanks
Mark

here it is ; pipe delimited file. if any data for a column has embdded pipe in it then the entire column will be in double quotes such as |"ZZXXT|05157"| However this is not my problem. The records coming like this are causing the problem. XXXX|413862|"ZZXXT|05157"|"ZZXX1|GN...

Hi All, I am trying to read a file through sequential stage. The file is a pipe delimited file. with quote double charcater. my data is coming in the following requirment. If an attribute value must contain both a pipe and double quotes then the entire attribute should be enclosed in double quotes a...

Thanks It worked

Regards
Mark

Thanks It worked

Regards
Mark

I found the file and it is corrupt. I will have to delete the job and
re-import it to create the config file.

Thanks
Mark

where can I find the Config 'file' for job #113

Regards
Mark