Hello, Surinder Ram,
In your example, below, do you mean that the separator values is the real VERTICAL LINE, of Unicode value \x007C ?
"Value_1"|"Value_2"|"Value_3"....
If so, I suppose that you would like that :
The syntax ""| would be changed into "|"
The syntax |"" would be changed into "|"
The syntax "" would be changed into "|"
The syntax "| , NOT followed by a double quote mark, would be changed into "|"
The syntax |" , NOT preceded by a double quote mark, would be changed into "|"
The syntax |, NOT surrounded by two double quote marks, would be changed into "|"
And, if any of these syntaxes, above, are found at the end of the current line, it would be changed into a single final double quote mark (")
And, also, when the normal separator form "|" or NO separator, at all, is found, at end of the current line, it would be changed into a single " character
In that case, just follow the few steps, below :
Go back to the very beginning of your file ( Ctrl + Origin )
Open the Replace dialog ( Ctrl + H )
In the Find what zone, type (?:(""\||\|""|""|(?<!")\|"|"\|(?!")|(?<!")\|(?!")|"\|")|(?<=[^"|\r\n]))(?=(\R))|(?1)
In the Replace with zone, type (?2":"|")
Click on the Replace All button
Et voilà !
So, from the original example, below, where :
Only, values 7 - 8 AND values 8 - 9 are correctly separated, on each line
The value9 is correctly ended, in the first line, only
value1"“|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”
value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9|””
value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9"”|
value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9"”
value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9|”
value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”|
value1"”|value2|"“value3"“value4”|value5|“value6|value7”|“value8”|“value9|
value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9
value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”|”
After that S/R, the different separators would be changed and the different values correctly separated, as below :
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
If this S/R ,just, solves your problem, next time, I’ll explain the regexes used !
Best Regards
guy038