Unanswered

Split string if longer than x number of characters into new row/new file

(0) Share

Report

Posted on by Community Power Pla...

Hi Community!

Looking for some help, I have created a flow which takes a CSV file- removes nulls, unwanted columns and transposes the column I want into a row and saves as a txt file. The purpose of this is for users to easily be able to copy and paste specific information into our system from an email attachment.

So from this:

Column1, Column 2, Column 3

A B C

to this:

B,B,B

I'm wondering if there is a way to split the string after a certain number of characters e.g. 20 and either create a new row on the CSV or creates a new TXT file with the data.

Screenshot of how the data starts and ends up:

Best Wishes

Amy

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @Anonymous

You can check the length of a string with length() and potentially split with substring().

Are you trying to shorten the output from FinalString compose action? What is the desired output?

Damien

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@DamoBird365 thanks for the advice!

The desired output would be if the output in the FinalString compose action is longer than 255 characters it would split the string either onto a new row or a new txt file without cutting off a value.

So just for ease an example if i wanted to split it if longer than 10 characters it would look like this:

final string compose output: 1234,2345,3456,4567,5678

Would go to (either new rows or new txt files):
1234,2345,
3456,4567,
5678

Many thanks for your help

Amy

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (2)

Report

Hi @Anonymous

My clever mate @Paulie78 came up with the following:

Where from is:
range(0, add(div(length(outputs('Compose')), 10), 1))
and Map is:
substring(outputs('Compose'), mul(item(), 10), if(greater(add(mul(item(), 10), 10), length(outputs('Compose'))), sub(length(outputs('Compose')), mul(item(), 10)), 10))

Substring is based on starting position and length.
The clever bit is the IF statement to cater for the last substring.

Oh, and I nearly forgot, you can then join() the array with a return line or however you please.

Damien

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@DamoBird365 and @Paulie78 words can't describe my feelings towards you both right now! Thank you so much, I've been looking at split and substring for almost a solid week trying to figure it out. Thank you so much!!!

Was this reply helpful? Yes No
JvdSchelling 18 on at

Like (0)

Report

Excellent stuff! Thanks. How would I go about if I want to chop up a long text string based on a more complex criterium: the last space prior to the maximum character count per line.

Example: let's say I want to create individual text lines of 40 characters.
Input: Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Desired output:
Lorem ipsum dolor sit amet, consectetur
adipiscing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna
aliqua.

Was this reply helpful? Yes No