Answered

Single Column Transformation

(0) Share

Report

Posted on by shuhn1229

Hi,

I have a collection containing a single text column. I am trying to replace the first three characters of each string within the column with a blank. For example, the prefix is VV-122343-2. I would like the output to be 122343-2. I've tried the replace and substitute functions for this, combined with ForAll, but nothing seems to be working. Can someone point me in the right direction?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @shuhn1229

Here's an example, where my data source is named "colTest" and the column I'm transforming is named "Value". My new column is named "New":

AddColumns(colTest,"New",Right(ThisRecord.Value,Len(ThisRecord.Value) - 3))

To do this directly in your collection, you can try something like the following. colTest is my data source and colNewData is my transformed data:

ForAll( colTest, Collect( colNewData, { NewValue: Right(Value, Len(Value) - 3) } ) )
shuhn1229 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you Rusk. This works great. Can I bug you for one more piece of advice? I was looking to use the replace function because I could replace only values containing the VV- prefix. I tried combining with an if statement and startswith below, but will not work. any thoughts?

AddColumns( MyCollection, "New", If( StartsWith( "VV-", ThisRecord.Value ), Right( ThisRecord.Value, Len(ThisRecord.value) - 3 ), ThisRecord.Value ) )
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Try this:

AddColumns( MyCollection, "New", If( Left(ThisRecord.Value, 3) = "VV-", Right(ThisRecord.Value, Len(ThisRecord.Value) - 3), ThisRecord.Value ) )
shuhn1229 on at

Like
a
(0)

Report
Copy link

Link copied!

you the man rusk