Regex - how to remove char with a specific location

[Hamder83]

Hi 

I have a csv file with a different amount of delimiters. It goes from 29-31.

For those lines that has 30 or 31 I wanna remove ; number 25 and/or 26.

I have this string:
Β;1474552;000004464165926;30/01/2022;ΘΖ;Κεντρ.Διακ.Θε ;ΑΘ;ΑΘΗΝΑ ;ΔΙΚΤΥΟ ΧΕΡΣΑΙΟ ;UBSEND GMBH ;ΑΛΕΞΑΝΔΡΑ ΒΛΑΧΑΚΗ 3ΟΣ ΟΡΟΦΟΣ ;001;00002,0;00000,00;ΑΜ; ; ; ;00002,97;00000,00;00000,00;00000,00;00002,97;31/01/2022;02/02/2022;...

And I use this formula to count how many ; there is:
REGEX_CountMatches([ΣΕΙΡΑ;ΝΟ ΤΙΜΟΛ;ΝΟ ΑΠΟΔ;ΗΜΕΡ.ΠΑΡΑΛ.;ΑΠΟ;ΠΕΡΙΓΡ;ΠΡΟΣ;ΠΕΡΙΓΡ;;ΑΠΟΣΤΟΛΕΑΣ;ΠΑΡΑΛΗΠΤΗΣ;ΤΕΜ;ΒΑΡΟΣ;ΑΞΙΑ ΜΕΤΑΦ.;ΑΛΛΕΣ ΥΠΗΡΕΣΙΕΣ;;;;ΑΞΙΑ ΑΛΛΩΝ ΥΠΗΡΕΣΙΩΝ;;;;ΣΥΝΟΛ.ΑΞΙΑ;ΗΜΕΡ.ΤΙΜΟΛ;ΗΜΕΡ.ΠΑΡΑΔ;ΠΑΡΑΛΑΒΩΝ;ΑΙΤΙΑ ΜΗ ΠΑΡΑΔ;Κ.ΚΟΣΤΟΥΣ;;ΑΝΑΓΝΩΡΙΣΤΙΚΟ;],';')


How do I replace a specific number of delimiter?


Kind regards

[AngelosPachis · Accepted solution]

Hi @Hamder83 ,

Probably there's a Regex way to do that, but I gave another method a try. So breaking it down to multiple tools, you can count how many columns/delimiters you have in each row (multi-row formula), find the max count for each row and only keep those that have 30-31. Then you can filter out 25/26 and concatenate everything back together.

Numbers in my workflow are slightly different as there were only 26 delimiters in the provided string. Also regarding the regex formula you used to count the ; is this your first row of data containing the concatenated column headers?

(Since this is greek), ευχαριστώ,

Άγγελος

[AngelosPachis]

@Hamder83any updates on this?

[atcodedog05]

Wow thats some amazing set of characters 🙂 @Hamder83