Answered

Convert Split function output into integer

(0) Share

Report

Posted on by jamielakes

In my flow, I pull data from a .tsv file we host, then split it into rows and then grab the headers from the first line and it all works fine.

The problem I have it trying to convert 2 of the values from String to Integer. The value should be a price so 1000.00 for example.

I get the value from the .tsv using the expression: split(item(),' ')?[4]

This works and pulls it as a string. I've tried many ways to convert this into a integer but nothing seems to be working. The most obvious way to me is int(split(item(),' ')?[4]) but this doesn't work.

This is the error I get: The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Any help would be appreciated. 🙂

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Can you show the exact output you get from using your expression:
split(item(),' ')?[4]

If it contains a decimal place, then you may need to convert it to a float instead of an int.

Was this reply helpful? Yes No
jamielakes 43 on at

Like (0)

Report
Copy link

Link copied!

The output is a price, so 1234.00 for eg. There is a decimal... what expression would convert my current one to a float?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can try:

float(split(item(),' ')?[4])

You would think that converting to int would just truncate the decimal part, but it fails instead.

Was this reply helpful? Yes No
jamielakes 43 on at

Like (0)

Report
Copy link

Link copied!

@grantjenkins

this is the error I get: The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Do any of your rows of data not have a value entered for this field (blank fields)? If so, what would you want to do with these? Ignore them, or default to 0.00?

Are you able to ensure the values being returned are strings "1234.00", not just 1234.00

See some examples below with regards to converting to int or float.

//Convert string with decimal places to float float('1234.00') //Convert string with decimal places to integer (will round appropriately) //Note that N0 means a Number with 0 decimal places int(formatNumber(float('1234.00'), 'N0')) //Convert string with no decimal places to integer int('1234') //Default to 0 if object doesn't contain the value we want, or it's set to null, and convert to integer int(coalesce(outputs('Data')?['Number'], '0')) //Default to 0.00 if object doesn't contain the value we want, or it's set to null, and convert to float float(coalesce(outputs('Data')?['Number'], '0.00'))

Was this reply helpful? Yes No
jamielakes 43 on at

Like (0)

Report
Copy link

Link copied!
@grantjenkins, amazing!

Where did you find those examples? I searched for hours and couldn't find anything remotely close to either of the bottom 2...

Here's what worked for me:

float(coalesce(split(item(),' ')?[4], '0.00'))

Was this reply helpful? Yes No