Hi,
I have record coming as below in txt file
"123", "T120 20" TFT Monitors" ,"KBC"
"234"," My name is sam","ABC"
i want to double code to be doubles something like below See double quote after "20":
"123", "T120 20"" TFT Monitors" ,"KBC"
"234"," My name is sam","ABC"
Thanks,
double code
Moderators: chulett, rschirm, roy
The data cannot be read correctly as columns in DataStage as it isn't well-formed.
If you specify the string columns are not having quotes your one column will be read as
You can then strip the leading double-quote and trailing double-quote from the string.
If you were to write this string to a sequential file and specify that the columns are to be quoted, the output would change the internal occurrences of double-quotes to double them as you specified. Another option is to use the pxereplace function (search DSXChange for posts to this user-written function) to do make '"' into '""' in your string.
If you specify the string columns are not having quotes your one column will be read as
Code: Select all
"T120 20" TFT Monitors"
If you were to write this string to a sequential file and specify that the columns are to be quoted, the output would change the internal occurrences of double-quotes to double them as you specified. Another option is to use the pxereplace function (search DSXChange for posts to this user-written function) to do make '"' into '""' in your string.