• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Create a field of spaces

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
FireGeek21
Veteran Member Send Private Message
Posts: 84
Veteran Member
12/12/2017 3:42 AM

I am using process flow to build a fixed field .txt file.  Several of the fields require a specific number of spaces because no value is being passed.  In SQL it is quite easy to use space(10) for a field with 10 spaces.  How can I do this in an Assign node maybe with javascript?  I have tried the addtrailingspaces(" ", 10  but the spaces appear as %20%20%20...  instead of true spaces.  Using "      " is out of the question because the header and trailer require over 2,000 spaces each.

Thanks for the help!

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
12/12/2017 11:00 AM
isn't there a 3rd parameter? Try setting that to null. addTrailingSpaces(" ",10,"")
Kyle Jorgensen
Veteran Member Send Private Message
Posts: 122
Veteran Member
12/12/2017 1:10 PM
Straight from the pflow.js file:

[code]/************************************************************ Function: addTrailingSpaces(String varValue, int finalLenthOfVarValue, isSpaceEscaped) Purpose: returns the String with trailing space escape chars to be used while attaching a variable in form URL. Can also be used to add actual space characters instead of the escaped space char by passing false for the argument isSpaceEscaped. If the 3rd argument is not passed at all, space will be escaped and then added. ************************************************************/ function addTrailingSpaces(varString, finalLengthOfVarString, isSpaceEscaped) { var retVal = "" var currLengthOfVarValue = varString.length; var leadingSpacesLength = finalLengthOfVarString - currLengthOfVarValue; var leadingSpacesStr = ""; var spaceChar = "%20"; if(isSpaceEscaped==undefined) isSpaceEscaped = true; if(!isSpaceEscaped) spaceChar = " "; for (var i=0;i
FireGeek21
Veteran Member Send Private Message
Posts: 84
Veteran Member
12/12/2017 4:15 PM
Ah, yes there is a 3rd parameter! Thanks. It helps to keep scrolling to the right to see all of the parameters. So simple! THANK YOU!!!