cut operator problem
hi guys
i have an attribute whit this type of data:
[ { "_id" : "ka5b14ub", "mineralTypeId" : "k5bza8u2", "group" : { "$numberInt" : "3" }, "flloorNo" : { "$numberInt" : "1" }, "wht0003" : { "$numberInt" : "20000000" }, "productionRate" : { "$numberInt" : "2000000" } } ]
i want to cut characters from index 43 to 51.but i face whit this error: string index out of range : -39
can you please help me?
Find more posts tagged with
Sort by:
1 - 5 of
51
dear @kayman
first of all thank you for your attention.
but i couldn't understand very well what should i do to use cut operator properly.
i will be thankful if you help me by detaile.
Since your data seems JSON format, why don't you try to use the JSON to Data operator instead? It's part of the text processing extension available on the marketplace in case you don't have it yet, and it nicely converts your string to separate attributes.
I assume you want to get a certain value out of your string(s) but as they will be different line by line that will never work.
So you need to use regex or in this case better json path
Like in attached examples
I assume you want to get a certain value out of your string(s) but as they will be different line by line that will never work.
So you need to use regex or in this case better json path
Like in attached examples
i import excel file and it's(i mean the string) a cell data.
I've removed all signs such as :']{" and it became like this:
| id k6qk7r1w mineralTypeId k5awyqmg group numberInt 1 flloorNo numberInt 1 productionRate numberInt 120000 wht0003 numberInt 1200000 possibleStorage numberInt 1800000 |
Why would you remove all of this? The strength is that these are json strings that make it actually easier to get the content.
Now, rather than cut you may be better of with the split operator if you want to extract specific data as your cut positions will be different for every row.
Would you mind sharing your process and a sample excel file?
Now, rather than cut you may be better of with the split operator if you want to extract specific data as your cut positions will be different for every row.
Would you mind sharing your process and a sample excel file?
I've mimicked the logic and it should work fine, you should verify what is entering the cut process, to see if it still containing the full string to start with and not cut off somewhat in the middle due to the format of your string...