Adding Multiple Spaces to a Text Field

(0) Share

Report

Posted on by dhaygood73

Is there a way to add a significant number of spaces to a text field, without pressing the space bar 296 times?

For example repeat(" ", 296)

I am creating a file where every record must be the same length and within each record there are fields that are located at specific start/end positions.

I considered using a counter and a forall to create the string, but was hoping there was a simple function like repeat, but can't find one.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@dhaygood73

Does this post answer your question? https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-leading-zeros-to-digits-using-Text/td-p/269238

Was this reply helpful? Yes No
Verified answer

dhaygood73 19 on at

Like (0)

Report
Copy link

Link copied!

Hi Drrickryp,

Thank you for this suggestion. I actually decided to just create several variables (Space50, Space25, Space10, Space5) and would combine them to create the amount of "space" I needed in the text file. So instead of hitting my space bar 296 times (and loosing count), this provided me the ability to reduce potential errors.

Thanks again

Was this reply helpful? Yes No
MilanPijanovic 26 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You might have run into the problem of adding multiple spaces.
Looks like PowerApps automatically erases something like that. However, you may instead user Char(127), which is a push of the delete button.

As of your broader question: You may create a function in a component, that receives a number (length of the string in question) and according to this returns a string of spaces (which are actualy deletes, but no one is going to see that anyways).

This article may give you an idea on creating such a function:
Power Apps Custom Functions & Reusable Code - Matthew Devaney

Was this reply helpful? Yes No
JemimaSherley 7 on at

Like (0)

Report
Copy link

Link copied!

Char(127) should work, Fine.
Thanks 💗

Was this reply helpful? Yes No