Hi,
Case:1 I have a multiple columns I need to combine into single column with commas, Can you please suggest the best way to get the desired results. I have attached the desired output and input please check
Case 2: Input
BARRETT, ORI A. |
MCKEE, V. |
CONRAD, NATALIE U. |
VELEZ, GAVIN B. |
CRAFT, UMA J. |
WARNER, DANTE Y. |
Now I need the the below as desired output.
A.ORI BARRETT |
V.MCKEE |
U.NATALIE CONRAD |
B.GAVIN VELEZ |
J.UMA CRAFT |
Y.DANTE WARNER |
Can you please help me to solve this both cases.
I used a Text to Columns tool to parse the input at the comma, which created two columns -- Input1 and Input2. I then used a RegEx tool's Parse function to identify and parse the first name and middle initial in Input2. After that, I used a Formula tool to concatenate the parsed out data into your desired output.
Hi navya123
By using text to column tool and then filtering you can achieve the output. Please refer attached workflow.
Thanks!