Concatenate Numbers Columns Using Semicolon

Question

Hi All,

I'm having trouble concatenating numbers in a given column to express it with semicolons.

Check Below:

F1
1938813
1941389
1941382
1941530
1942941
1943184
1943638
1943636

But I want a semicolon between each string

1938813;1941389;1941382;1941530;1942941;1943184;1943638;1943636

I would appreciate the help! 🙂

** Update** thank you all, this was a huge help 🙂

AngelosPachis · Accepted Answer

Hi @Shan_Drex12 ,

I've mocked up a workflow that answers your question.

Output

You need a field to become your column header and then you can use the cross-tab tool. Let me know if that worked for you.

Regards,

Angelos

Maskell_Rascal · Accepted Answer

Hi @Shan_Drex12

You can use the Summarize tool to concatenate, and even change the separator to your liking! Just make sure to convert the column you're wanting to concatenate to a string first. I'd recommend a V_WString, since it will adapt to character size as needed.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Qiu · Accepted Answer

@Shan_Drex12 
Basically same with @AngelosPachis , but I did not use Record ID.
The Summarize Tool will concatenate the rows if the input is a string.

grazitti_sapna · Accepted Answer

Hi @Shan_Drex12 , as there is no specified criteria so I assume you are just trying to concatenate a single column, so here are 2 possible solutions that I can think of.

I hope this helps and mark this post as solution if it works for you.

Thanks.