Forum Discussion
Advocate IIReplace carriage return in dataset
wi11iamr It would appear you can do this in the Desktop.
In the Data section, click "Edit Queries" in the ribbon.
Select the table you want, and right click the column header
Select "Replace Values", click in the "Value To Find"
Select "Advanced Options" check "Replace using special characters"
Select "Insert special character"
Click "Carriage Return" and a carriage return should show in your values section
put comma in "Replace With"
OK
Close and Apply
This is "in theory" as I didn't directly test it, but the sequence appears to support the action.
wi11iamr It would appear you can do this in the Desktop.
In the Data section, click "Edit Queries" in the ribbon.
Select the table you want, and right click the column header
Select "Replace Values", click in the "Value To Find"
Select "Advanced Options" check "Replace using special characters"
Select "Insert special character"
Click "Carriage Return" and a carriage return should show in your values section
put comma in "Replace With"
OK
Close and Apply
This is "in theory" as I didn't directly test it, but the sequence appears to support the action.
- wi11iamr
Thanks Eno, the solution you propose is however unfortunately to replace characters with a carriage return. My dilemma is to replace a carriage return with a character.
i think Anonymous solution should work for replacing with a character
below image did that when i have it for line feed and replaced it with '-'
After
- wi11iamr
Thank you, it appears I was too hasty (and naieve) in my initial response.
Anonymous - your clarification was indeed correct, thank you.
Anonymous - thank you for taking the time to point this out to me
