Stack Overflow
Stack Overflow

Questions tagged [data-conversion]

This tag refers to the process of converting the data type of one piece of information into another type.

1963 questions
0
votes
1 answer

SSIS data load truncates values into destination table

I have an SSIS package with a simple Source(vertica query) and Destination (sql DB). When I load the data my data values are cut off. For example, I have a Country code and this is listed as "C" instead of "CN" . I tried to put a DATA CONVERSION…
tzee
  • 65
  • 1
  • 5
0
votes
2 answers

Skip special characters while converting ASCII to HEX in C

I need help to get the ascii to hex data output only for alphanumeric characters(excluding special characters). Input String is: 86741-30011 Expected result is: 38363734313330303131 Actual Result is: 3836373431 Output breaks after non…
Ashwini
  • 19
  • 4
0
votes
1 answer

How to convert JSON string to PHP object or array creation *code*

FIRSTLY: This is a totally different question - How to convert JSON string to array MY QUESTION... I have a valid JSON string assigned to a php variable, $json. I know that I can run it into json_decode($json, true); to parse into a php array at…
ajmedway
  • 1,492
  • 14
  • 28
0
votes
1 answer

Error while adding Schema to Spark DataFrame loaded from file

val tableDF = spark.read.option("delimiter",",").csv("/Volumes/Data/ap/click/test.csv") import org.apache.spark.sql.types.{StringType, StructField, StructType, IntegerType} val schemaTd =…
kiran kumar
  • 81
  • 2
  • 9
0
votes
0 answers

how to convert specific string(dd-jun-yyyy hh:mm:ss) to date format in ssis

I have a problem trying to convert a String to DateTime (from DT-WSTR to TIMESTAMP) usually I can do the conversion with just the DATA Conversion tool with a date format dd / mm / yyy hh: mm: ss there I have a slightly different format to convert…
karDEVproj
  • 11
  • 4
0
votes
0 answers

Convert the CSV file data to EXCEL(.xls or .xlsx) data using python

I have csv file data. and I want to convert that csv file data either directly to excel file(.xls or .xlsx) or by reading csv file data and write to excel file. at the end format should be in correct...means number types should be in number,date…
Aneel kumar
  • 1
  • 1
0
votes
0 answers

How do i convert following response to json

Image shows the response, need to convert this into json, below is the structure of response am getting. I received the following response on xcode (Objective-C). How can I convert this to JSON-compatible on Objective-C itself? { "abc" =…
HSBP
  • 735
  • 2
  • 8
  • 22
0
votes
2 answers

Python - replacing string/symbol with numbers

I have some columns in a pandas dataframe consisting of strings, which I want to convert to numbers (float). The problem is the following: some entries consist of just '-' and others are like '1E-06'. Is there an easy way to replace just the '-'…
MarcoC
  • 119
  • 10
0
votes
1 answer

Custom message builder to handle binary data - wso2 EI

1) I have an incoming message from IBM Legacy system, i need to convert it into XML/text and send it back to a client using WSO2 EI 6.1.1. 2) I am using apache kafka as a messaging queue here, hence i have created an inbound endpoint in wso2 EI. 3)…
Naresh sivaram
  • 37
  • 1
  • 11
0
votes
1 answer

Inconsistently getting NumberFormatException when trying to convert binary to hex

If use variable bin1 it wont convert, however if i replace the parameter with bin2 it seems to work. I tried using long instead of int. It's still the same. public class Test{ public static void main(String[] args) { String bin1 =…
BWB
  • 5
  • 3
0
votes
1 answer

Removing zeros from a column with pandas and matplotlib

I am using pandas and matplotlib to evaluate an excel sheet that I have converted to a dataframe. However, two of my columns have zeros as values in some of the rows, which I need to remove. We are talking a couple thousand rows for the dataframe…
Paul Blessing
  • 11
  • 3
0
votes
0 answers

SSIS Data Conversion The data value cannot be converted for reasons other than sign mismatch or data overflow

Does anyone know why I'm getting error below when converting string [DT_STR] to Unicode string [DT_WSTR] in SSIS Data Conversion? ErrorCode: -1071607681 ErrorCode - Description: The data value cannot be converted for reasons other than sign…
JZ Tay
  • 61
  • 2
  • 10
0
votes
1 answer

Need to convert data (byte value into hex and hex characters as ASCII characters)

Working: I am reading a byte from memory (EEPROM/FLASH etc) and then i want to send this byte to computer not as actual value but as a ascii characters of its hex value. e.g i read 160 from memory, which is 0xA0 in hex, now i want to send this…
BetaEngineer
  • 3
  • 6
0
votes
1 answer

How to convert dataset values into percentiles with a function?

I'm trying to convert dataset values into percentiles and I created a function for this problem but it doesn't seem to work, however, when I run the same code used within the function just by itself, it works. Would someone please be able to help me…
michael0196
  • 1,497
  • 1
  • 9
  • 21
0
votes
0 answers

MASM - How to input a line of ascii codes to output a string

Anyone knows how to convert this in MASM? I'm having trouble storing string in data segments along with null terminator. I did a project similar to this, but vice-versa. Inputting a string to ouput the corresponding ASCII values. Now I'm trying to…
CHARot
  • 9
  • 1
1 2 3
…
99 100